--
-- File generated with SQLiteStudio v3.4.4 on Mon May 22 19:29:23 2023
--
-- Text encoding used: System
--
PRAGMA foreign_keys = off;
BEGIN TRANSACTION;

-- Table: BroomRaceTimesDynamic
CREATE TABLE IF NOT EXISTS BroomRaceTimesDynamic ( RacerName STRING COLLATE NOCASE NOT NULL, RaceName  NOT NULL, BestTime REAL NOT NULL, MissionRelevant BOOLEAN NOT NULL DEFAULT( 0 ),CONSTRAINT Pk_BroomRaceTimesDynamic PRIMARY KEY (RacerName,RaceName ) );
INSERT OR REPLACE INTO BroomRaceTimesDynamic (RacerName, RaceName, BestTime, MissionRelevant) VALUES ('ElsieMorgan', 'BRR_01', 253.12, 0);
INSERT OR REPLACE INTO BroomRaceTimesDynamic (RacerName, RaceName, BestTime, MissionRelevant) VALUES ('ElsieMorgan', 'BRR_02', 234.61, 0);
INSERT OR REPLACE INTO BroomRaceTimesDynamic (RacerName, RaceName, BestTime, MissionRelevant) VALUES ('ElsieMorgan', 'BRR_03', 251.16, 0);
INSERT OR REPLACE INTO BroomRaceTimesDynamic (RacerName, RaceName, BestTime, MissionRelevant) VALUES ('EzraQuintrell', 'BRR_01', 243.87, 0);
INSERT OR REPLACE INTO BroomRaceTimesDynamic (RacerName, RaceName, BestTime, MissionRelevant) VALUES ('EzraQuintrell', 'BRR_02', 238.12, 0);
INSERT OR REPLACE INTO BroomRaceTimesDynamic (RacerName, RaceName, BestTime, MissionRelevant) VALUES ('EzraQuintrell', 'BRR_0', 243.25, 0);
INSERT OR REPLACE INTO BroomRaceTimesDynamic (RacerName, RaceName, BestTime, MissionRelevant) VALUES ('ImeldaReyes', 'BRR_01', 240.54, 1);
INSERT OR REPLACE INTO BroomRaceTimesDynamic (RacerName, RaceName, BestTime, MissionRelevant) VALUES ('ImeldaReyes', 'BRR_02', 246.22, 1);
INSERT OR REPLACE INTO BroomRaceTimesDynamic (RacerName, RaceName, BestTime, MissionRelevant) VALUES ('ImeldaReyes', 'BRR_03', 262.43, 1);
INSERT OR REPLACE INTO BroomRaceTimesDynamic (RacerName, RaceName, BestTime, MissionRelevant) VALUES ('LottieFernsby', 'BRR_01', 215.73, 0);
INSERT OR REPLACE INTO BroomRaceTimesDynamic (RacerName, RaceName, BestTime, MissionRelevant) VALUES ('LottieFernsby', 'BRR_02', 244.03, 0);
INSERT OR REPLACE INTO BroomRaceTimesDynamic (RacerName, RaceName, BestTime, MissionRelevant) VALUES ('LottieFernsby', 'BRR_03', 157.92, 0);
INSERT OR REPLACE INTO BroomRaceTimesDynamic (RacerName, RaceName, BestTime, MissionRelevant) VALUES ('RubyWiel', 'BRR_01', 292.08, 0);
INSERT OR REPLACE INTO BroomRaceTimesDynamic (RacerName, RaceName, BestTime, MissionRelevant) VALUES ('RubyWiel', 'BRR_02', 215.36, 0);
INSERT OR REPLACE INTO BroomRaceTimesDynamic (RacerName, RaceName, BestTime, MissionRelevant) VALUES ('RubyWiel', 'BRR_03', 233.74, 0);


COMMIT TRANSACTION;
PRAGMA foreign_keys = on;
